Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 5250 |
| Missing cells | 9646 |
| Missing cells (%) | 8.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 907.6 KiB |
| Average record size in memory | 177.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Text | 6 |
| Categorical | 5 |
| Boolean | 6 |
Modified_Operating_Hours_ has constant value "" | Constant |
Fuel_Station_open_to_public_ has constant value "" | Constant |
businessunit_number is highly overall correlated with businessunit_status_code and 2 other fields | High correlation |
businessunit_status_code is highly overall correlated with businessunit_number and 2 other fields | High correlation |
bu_num is highly overall correlated with businessunit_number and 2 other fields | High correlation |
businessunit_banner_description is highly overall correlated with businessunit_type_description | High correlation |
businessunit_type_description is highly overall correlated with businessunit_number and 2 other fields | High correlation |
businessunit_isstoreopen is highly overall correlated with businessunit_status_code | High correlation |
Pharmacy_open_to_public_ is highly overall correlated with Grocery_delivery_status and 1 other fields | High correlation |
Grocery_delivery_status is highly overall correlated with Pharmacy_open_to_public_ and 1 other fields | High correlation |
Online_grocery_pickup_status is highly overall correlated with Pharmacy_open_to_public_ and 1 other fields | High correlation |
businessunit_banner_description is highly imbalanced (52.3%) | Imbalance |
businessunit_isstoreopen is highly imbalanced (96.2%) | Imbalance |
op_status is highly imbalanced (99.3%) | Imbalance |
Pharmacy_open_to_public_ is highly imbalanced (99.7%) | Imbalance |
Modified_Operating_Hours_ has 5247 (99.9%) missing values | Missing |
Grocery_delivery_service has 435 (8.3%) missing values | Missing |
Grocery_delivery_status has 2385 (45.4%) missing values | Missing |
Online_grocery_pickup has 106 (2.0%) missing values | Missing |
Online_grocery_pickup_status has 1473 (28.1%) missing values | Missing |
objectid has unique values | Unique |
businessunit_number has unique values | Unique |
bu_num has unique values | Unique |
Reproduction
| Analysis started | 2023-10-22 10:05:59.441634 |
|---|---|
| Analysis finished | 2023-10-22 10:06:09.218187 |
| Duration | 9.78 seconds |
| Software version | ydata-profiling vv4.6.0 |
| Download configuration | config.json |
X
Real number (ℝ)
| Distinct | 5248 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -91.520243 |
| Minimum | -159.36503 |
|---|---|
| Maximum | -65.674303 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 5250 |
| Negative (%) | 100.0% |
| Memory size | 41.1 KiB |
Quantile statistics
| Minimum | -159.36503 |
|---|---|
| 5-th percentile | -119.18436 |
| Q1 | -97.132078 |
| median | -88.420169 |
| Q3 | -81.753295 |
| 95-th percentile | -74.692686 |
| Maximum | -65.674303 |
| Range | 93.690722 |
| Interquartile range (IQR) | 15.378783 |
Descriptive statistics
| Standard deviation | 13.529964 |
|---|---|
| Coefficient of variation (CV) | -0.14783575 |
| Kurtosis | 1.3174184 |
| Mean | -91.520243 |
| Median Absolute Deviation (MAD) | 7.550761 |
| Skewness | -1.0579582 |
| Sum | -480481.28 |
| Variance | 183.05993 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -84.848736 | 2 | < 0.1% |
| -90.324403 | 2 | < 0.1% |
| -94.149054 | 1 | < 0.1% |
| -117.266426 | 1 | < 0.1% |
| -83.470749 | 1 | < 0.1% |
| -75.091761 | 1 | < 0.1% |
| -120.609275 | 1 | < 0.1% |
| -85.663857 | 1 | < 0.1% |
| -96.856976 | 1 | < 0.1% |
| -76.928412 | 1 | < 0.1% |
| Other values (5238) | 5238 |
| Value | Count | Frequency (%) |
| -159.365025 | 1 | |
| -158.075334 | 1 | |
| -158.034591 | 1 | |
| -158.005571 | 1 | |
| -157.978362 | 1 | |
| -157.974452 | 1 | |
| -157.862004 | 1 | |
| -157.843233 | 1 | |
| -157.842705 | 1 | |
| -156.454892 | 1 |
| Value | Count | Frequency (%) |
| -65.674303 | 1 | |
| -65.807268 | 1 | |
| -65.889641 | 1 | |
| -65.995746 | 1 | |
| -65.997031 | 1 | |
| -66.015882 | 1 | |
| -66.020899 | 1 | |
| -66.076049 | 1 | |
| -66.087612 | 1 | |
| -66.095026 | 1 |
Y
Real number (ℝ)
| Distinct | 5247 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.45154 |
| Minimum | 17.980621 |
|---|---|
| Maximum | 64.856378 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.1 KiB |
Quantile statistics
| Minimum | 17.980621 |
|---|---|
| 5-th percentile | 28.029205 |
| Q1 | 32.959555 |
| median | 36.181191 |
| Q3 | 40.369625 |
| 95-th percentile | 44.552793 |
| Maximum | 64.856378 |
| Range | 46.875757 |
| Interquartile range (IQR) | 7.4100702 |
Descriptive statistics
| Standard deviation | 5.2184587 |
|---|---|
| Coefficient of variation (CV) | 0.14316154 |
| Kurtosis | 0.55972775 |
| Mean | 36.45154 |
| Median Absolute Deviation (MAD) | 3.6537935 |
| Skewness | -0.052431905 |
| Sum | 191370.58 |
| Variance | 27.232311 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 41.473938 | 2 | < 0.1% |
| 29.470675 | 2 | < 0.1% |
| 42.999723 | 2 | < 0.1% |
| 47.658489 | 1 | < 0.1% |
| 39.999062 | 1 | < 0.1% |
| 37.340296 | 1 | < 0.1% |
| 38.088633 | 1 | < 0.1% |
| 32.862217 | 1 | < 0.1% |
| 40.224885 | 1 | < 0.1% |
| 33.069254 | 1 | < 0.1% |
| Other values (5237) | 5237 |
| Value | Count | Frequency (%) |
| 17.980621 | 1 | |
| 17.993681 | 1 | |
| 17.99736 | 1 | |
| 18.016813 | 1 | |
| 18.044336 | 1 | |
| 18.122626 | 1 | |
| 18.141237 | 1 | |
| 18.155224 | 1 | |
| 18.243301 | 1 | |
| 18.246762 | 1 |
| Value | Count | Frequency (%) |
| 64.856378 | 1 | |
| 61.568719 | 1 | |
| 61.309037 | 1 | |
| 61.211988 | 1 | |
| 61.192239 | 1 | |
| 61.140195 | 1 | |
| 60.564278 | 1 | |
| 57.811934 | 1 | |
| 55.375474 | 1 | |
| 48.818547 | 1 |
objectid
Real number (ℝ)
UNIQUE 
| Distinct | 5250 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32402.935 |
| Minimum | 29040 |
|---|---|
| Maximum | 36706 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.1 KiB |
Quantile statistics
| Minimum | 29040 |
|---|---|
| 5-th percentile | 29377.45 |
| Q1 | 30471.25 |
| median | 32128.5 |
| Q3 | 34228.75 |
| 95-th percentile | 36274.55 |
| Maximum | 36706 |
| Range | 7666 |
| Interquartile range (IQR) | 3757.5 |
Descriptive statistics
| Standard deviation | 2173.7084 |
|---|---|
| Coefficient of variation (CV) | 0.067083689 |
| Kurtosis | -1.0958443 |
| Mean | 32402.935 |
| Median Absolute Deviation (MAD) | 1873.5 |
| Skewness | 0.27415283 |
| Sum | 1.7011541 × 108 |
| Variance | 4725008.1 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 29040 | 1 | < 0.1% |
| 33536 | 1 | < 0.1% |
| 33533 | 1 | < 0.1% |
| 33532 | 1 | < 0.1% |
| 33531 | 1 | < 0.1% |
| 33530 | 1 | < 0.1% |
| 33529 | 1 | < 0.1% |
| 33527 | 1 | < 0.1% |
| 33525 | 1 | < 0.1% |
| 33524 | 1 | < 0.1% |
| Other values (5240) | 5240 |
| Value | Count | Frequency (%) |
| 29040 | 1 | |
| 29041 | 1 | |
| 29042 | 1 | |
| 29043 | 1 | |
| 29044 | 1 | |
| 29045 | 1 | |
| 29046 | 1 | |
| 29047 | 1 | |
| 29048 | 1 | |
| 29049 | 1 |
| Value | Count | Frequency (%) |
| 36706 | 1 | |
| 36705 | 1 | |
| 36704 | 1 | |
| 36702 | 1 | |
| 36700 | 1 | |
| 36698 | 1 | |
| 36695 | 1 | |
| 36693 | 1 | |
| 36690 | 1 | |
| 36688 | 1 |
| Distinct | 4795 |
|---|---|
| Distinct (%) | 91.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
Length
| Max length | 42 |
|---|---|
| Median length | 36 |
| Mean length | 13.968762 |
| Min length | 5 |
Characters and Unicode
| Total characters | 73336 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4435 ? |
|---|---|
| Unique (%) | 84.5% |
Sample
| 1st row | ROGERS, AR |
|---|---|
| 2nd row | TUNKHANNOCK, PA |
| 3rd row | TAHLEQUAH OK |
| 4th row | TRACY, CA |
| 5th row | BENTONVILLE, AR |
| Value | Count | Frequency (%) |
| tx | 585 | 4.4% |
| fl | 371 | 2.8% |
| ca | 306 | 2.3% |
| ga | 211 | 1.6% |
| nc | 210 | 1.6% |
| il | 180 | 1.4% |
| oh | 167 | 1.3% |
| city | 163 | 1.2% |
| la | 158 | 1.2% |
| pa | 157 | 1.2% |
| Other values (3243) | 10690 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7957 | 10.9% | |
| A | 6356 | 8.7% |
| N | 5106 | 7.0% |
| E | 5093 | 6.9% |
| L | 4848 | 6.6% |
| O | 4608 | 6.3% |
| I | 3791 | 5.2% |
| R | 3712 | 5.1% |
| T | 3649 | 5.0% |
| S | 3397 | 4.6% |
| Other values (60) | 24819 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 60212 | |
| Space Separator | 7957 | 10.9% |
| Other Punctuation | 2595 | 3.5% |
| Lowercase Letter | 908 | 1.2% |
| Open Punctuation | 678 | 0.9% |
| Close Punctuation | 678 | 0.9% |
| Decimal Number | 241 | 0.3% |
| Dash Punctuation | 65 | 0.1% |
| Modifier Symbol | 2 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 6356 | 10.6% |
| N | 5106 | 8.5% |
| E | 5093 | 8.5% |
| L | 4848 | 8.1% |
| O | 4608 | 7.7% |
| I | 3791 | 6.3% |
| R | 3712 | 6.2% |
| T | 3649 | 6.1% |
| S | 3397 | 5.6% |
| C | 2561 | 4.3% |
| Other values (16) | 17091 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 111 | |
| e | 92 | |
| o | 91 | |
| n | 80 | |
| l | 76 | 8.4% |
| r | 74 | 8.1% |
| i | 55 | 6.1% |
| s | 54 | 5.9% |
| t | 52 | 5.7% |
| d | 33 | 3.6% |
| Other values (14) | 190 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 83 | |
| 2 | 42 | |
| 0 | 37 | |
| 6 | 15 | 6.2% |
| 7 | 13 | 5.4% |
| 3 | 13 | 5.4% |
| 4 | 13 | 5.4% |
| 5 | 11 | 4.6% |
| 8 | 9 | 3.7% |
| 9 | 5 | 2.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 2422 | |
| . | 86 | 3.3% |
| / | 42 | 1.6% |
| & | 38 | 1.5% |
| ' | 7 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 7957 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 678 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 678 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 65 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 61120 | |
| Common | 12216 | 16.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 6356 | 10.4% |
| N | 5106 | 8.4% |
| E | 5093 | 8.3% |
| L | 4848 | 7.9% |
| O | 4608 | 7.5% |
| I | 3791 | 6.2% |
| R | 3712 | 6.1% |
| T | 3649 | 6.0% |
| S | 3397 | 5.6% |
| C | 2561 | 4.2% |
| Other values (40) | 17999 |
Common
| Value | Count | Frequency (%) |
| 7957 | ||
| , | 2422 | 19.8% |
| ( | 678 | 5.6% |
| ) | 678 | 5.6% |
| . | 86 | 0.7% |
| 1 | 83 | 0.7% |
| - | 65 | 0.5% |
| / | 42 | 0.3% |
| 2 | 42 | 0.3% |
| & | 38 | 0.3% |
| Other values (10) | 125 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 73336 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7957 | 10.9% | |
| A | 6356 | 8.7% |
| N | 5106 | 7.0% |
| E | 5093 | 6.9% |
| L | 4848 | 6.6% |
| O | 4608 | 6.3% |
| I | 3791 | 5.2% |
| R | 3712 | 5.1% |
| T | 3649 | 5.0% |
| S | 3397 | 4.6% |
| Other values (60) | 24819 |
businessunit_number
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 5250 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3184.756 |
| Minimum | 1 |
|---|---|
| Maximum | 9894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 278.45 |
| Q1 | 1371.25 |
| median | 2810.5 |
| Q3 | 4925.75 |
| 95-th percentile | 6955.75 |
| Maximum | 9894 |
| Range | 9893 |
| Interquartile range (IQR) | 3554.5 |
Descriptive statistics
| Standard deviation | 2159.4932 |
|---|---|
| Coefficient of variation (CV) | 0.6780718 |
| Kurtosis | -0.73966895 |
| Mean | 3184.756 |
| Median Absolute Deviation (MAD) | 1694 |
| Skewness | 0.47704628 |
| Sum | 16719969 |
| Variance | 4663411 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 5894 | 1 | < 0.1% |
| 5891 | 1 | < 0.1% |
| 5890 | 1 | < 0.1% |
| 589 | 1 | < 0.1% |
| 5889 | 1 | < 0.1% |
| 5888 | 1 | < 0.1% |
| 5886 | 1 | < 0.1% |
| 5884 | 1 | < 0.1% |
| 5883 | 1 | < 0.1% |
| Other values (5240) | 5240 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 11 | 1 |
| Value | Count | Frequency (%) |
| 9894 | 1 | |
| 8958 | 1 | |
| 8930 | 1 | |
| 8331 | 1 | |
| 8299 | 1 | |
| 8298 | 1 | |
| 8297 | 1 | |
| 8296 | 1 | |
| 8295 | 1 | |
| 8294 | 1 |
businessunit_banner_description
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
| WM Supercenter | |
|---|---|
| Neighborhood Market | |
| Sam's Club | |
| Wal-Mart | |
| WM On Campus/RX Facilities | 16 |
| Other values (3) | 10 |
Length
| Max length | 26 |
|---|---|
| Median length | 14 |
| Mean length | 13.824381 |
| Min length | 8 |
Characters and Unicode
| Total characters | 72578 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | WM Supercenter |
|---|---|
| 2nd row | WM Supercenter |
| 3rd row | WM Supercenter |
| 4th row | WM Supercenter |
| 5th row | WM Supercenter |
Common Values
| Value | Count | Frequency (%) |
| WM Supercenter | 3575 | |
| Neighborhood Market | 683 | 13.0% |
| Sam's Club | 602 | 11.5% |
| Wal-Mart | 364 | 6.9% |
| WM On Campus/RX Facilities | 16 | 0.3% |
| Walmart Fuel Station | 8 | 0.2% |
| WM ONLINE PICKUP/DELIVERY | 1 | < 0.1% |
| STAND ALONE PICKUP | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| wm | 3592 | |
| supercenter | 3575 | |
| neighborhood | 683 | 6.7% |
| market | 683 | 6.7% |
| sam's | 602 | 5.9% |
| club | 602 | 5.9% |
| wal-mart | 364 | 3.6% |
| campus/rx | 16 | 0.2% |
| facilities | 16 | 0.2% |
| on | 16 | 0.2% |
| Other values (8) | 29 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 12115 | |
| r | 8888 | |
| 4928 | 6.8% | |
| t | 4662 | 6.4% |
| M | 4639 | 6.4% |
| u | 4201 | 5.8% |
| S | 4186 | 5.8% |
| W | 3964 | 5.5% |
| n | 3599 | 5.0% |
| p | 3591 | 4.9% |
| Other values (32) | 17805 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 52470 | |
| Uppercase Letter | 14197 | 19.6% |
| Space Separator | 4928 | 6.8% |
| Other Punctuation | 619 | 0.9% |
| Dash Punctuation | 364 | 0.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 4639 | |
| S | 4186 | |
| W | 3964 | |
| N | 687 | 4.8% |
| C | 620 | 4.4% |
| F | 24 | 0.2% |
| O | 18 | 0.1% |
| R | 17 | 0.1% |
| X | 16 | 0.1% |
| P | 4 | < 0.1% |
| Other values (10) | 22 | 0.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 12115 | |
| r | 8888 | |
| t | 4662 | 8.9% |
| u | 4201 | 8.0% |
| n | 3599 | 6.9% |
| p | 3591 | 6.8% |
| c | 3591 | 6.8% |
| a | 2069 | 3.9% |
| o | 2057 | 3.9% |
| h | 1366 | 2.6% |
| Other values (8) | 6331 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 602 | |
| / | 17 | 2.7% |
Space Separator
| Value | Count | Frequency (%) |
| 4928 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 364 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 66667 | |
| Common | 5911 | 8.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 12115 | |
| r | 8888 | |
| t | 4662 | 7.0% |
| M | 4639 | 7.0% |
| u | 4201 | 6.3% |
| S | 4186 | 6.3% |
| W | 3964 | 5.9% |
| n | 3599 | 5.4% |
| p | 3591 | 5.4% |
| c | 3591 | 5.4% |
| Other values (28) | 13231 |
Common
| Value | Count | Frequency (%) |
| 4928 | ||
| ' | 602 | 10.2% |
| - | 364 | 6.2% |
| / | 17 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72578 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 12115 | |
| r | 8888 | |
| 4928 | 6.8% | |
| t | 4662 | 6.4% |
| M | 4639 | 6.4% |
| u | 4201 | 5.8% |
| S | 4186 | 5.8% |
| W | 3964 | 5.5% |
| n | 3599 | 5.0% |
| p | 3591 | 4.9% |
| Other values (32) | 17805 |
businessunit_type_description
Categorical
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
| Retail | |
|---|---|
| Wholesale |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.344 |
| Min length | 6 |
Characters and Unicode
| Total characters | 33306 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Retail |
|---|---|
| 2nd row | Retail |
| 3rd row | Retail |
| 4th row | Retail |
| 5th row | Retail |
Common Values
| Value | Count | Frequency (%) |
| Retail | 4648 | |
| Wholesale | 602 | 11.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| retail | 4648 | |
| wholesale | 602 | 11.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 5852 | |
| l | 5852 | |
| a | 5250 | |
| R | 4648 | |
| t | 4648 | |
| i | 4648 | |
| W | 602 | 1.8% |
| h | 602 | 1.8% |
| o | 602 | 1.8% |
| s | 602 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 28056 | |
| Uppercase Letter | 5250 | 15.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 5852 | |
| l | 5852 | |
| a | 5250 | |
| t | 4648 | |
| i | 4648 | |
| h | 602 | 2.1% |
| o | 602 | 2.1% |
| s | 602 | 2.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 4648 | |
| W | 602 | 11.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 33306 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 5852 | |
| l | 5852 | |
| a | 5250 | |
| R | 4648 | |
| t | 4648 | |
| i | 4648 | |
| W | 602 | 1.8% |
| h | 602 | 1.8% |
| o | 602 | 1.8% |
| s | 602 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 33306 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 5852 | |
| l | 5852 | |
| a | 5250 | |
| R | 4648 | |
| t | 4648 | |
| i | 4648 | |
| W | 602 | 1.8% |
| h | 602 | 1.8% |
| o | 602 | 1.8% |
| s | 602 | 1.8% |
businessunit_isstoreopen
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.3 KiB |
| True | |
|---|---|
| False | 21 |
| Value | Count | Frequency (%) |
| True | 5229 | |
| False | 21 | 0.4% |
| Distinct | 5241 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
Length
| Max length | 41 |
|---|---|
| Median length | 35 |
| Mean length | 17.665524 |
| Min length | 8 |
Characters and Unicode
| Total characters | 92744 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 5234 ? |
|---|---|
| Unique (%) | 99.7% |
Sample
| 1st row | 2110 W WALNUT ST |
|---|---|
| 2nd row | 808 HUNTER HWY |
| 3rd row | 2020 S MUSKOGEE AVE |
| 4th row | 3010 W GRANT LINE RD |
| 5th row | 406 S WALTON BLVD |
| Value | Count | Frequency (%) |
| rd | 994 | 5.0% |
| st | 790 | 4.0% |
| ave | 619 | 3.1% |
| dr | 571 | 2.9% |
| blvd | 569 | 2.9% |
| s | 533 | 2.7% |
| w | 506 | 2.6% |
| n | 500 | 2.5% |
| e | 468 | 2.4% |
| highway | 357 | 1.8% |
| Other values (5682) | 13788 |
Most occurring characters
| Value | Count | Frequency (%) |
| 14445 | 15.6% | |
| E | 5556 | 6.0% |
| R | 4977 | 5.4% |
| A | 4865 | 5.2% |
| 0 | 4542 | 4.9% |
| 1 | 4176 | 4.5% |
| S | 3806 | 4.1% |
| N | 3742 | 4.0% |
| T | 3673 | 4.0% |
| D | 3450 | 3.7% |
| Other values (42) | 39512 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 56026 | |
| Decimal Number | 22138 | 23.9% |
| Space Separator | 14445 | 15.6% |
| Other Punctuation | 101 | 0.1% |
| Dash Punctuation | 24 | < 0.1% |
| Lowercase Letter | 10 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 5556 | 9.9% |
| R | 4977 | 8.9% |
| A | 4865 | 8.7% |
| S | 3806 | 6.8% |
| N | 3742 | 6.7% |
| T | 3673 | 6.6% |
| D | 3450 | 6.2% |
| L | 3357 | 6.0% |
| O | 2951 | 5.3% |
| I | 2727 | 4.9% |
| Other values (17) | 16922 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4542 | |
| 1 | 4176 | |
| 5 | 2647 | |
| 2 | 2531 | |
| 3 | 1919 | |
| 4 | 1592 | 7.2% |
| 7 | 1275 | 5.8% |
| 6 | 1239 | 5.6% |
| 9 | 1115 | 5.0% |
| 8 | 1102 | 5.0% |
Lowercase Letter
| Value | Count | Frequency (%) |
| y | 2 | |
| d | 2 | |
| k | 1 | |
| w | 1 | |
| c | 1 | |
| a | 1 | |
| m | 1 | |
| e | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 86 | |
| # | 6 | 5.9% |
| , | 4 | 4.0% |
| / | 3 | 3.0% |
| ' | 2 | 2.0% |
Space Separator
| Value | Count | Frequency (%) |
| 14445 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 24 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 56036 | |
| Common | 36708 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 5556 | 9.9% |
| R | 4977 | 8.9% |
| A | 4865 | 8.7% |
| S | 3806 | 6.8% |
| N | 3742 | 6.7% |
| T | 3673 | 6.6% |
| D | 3450 | 6.2% |
| L | 3357 | 6.0% |
| O | 2951 | 5.3% |
| I | 2727 | 4.9% |
| Other values (25) | 16932 |
Common
| Value | Count | Frequency (%) |
| 14445 | ||
| 0 | 4542 | 12.4% |
| 1 | 4176 | 11.4% |
| 5 | 2647 | 7.2% |
| 2 | 2531 | 6.9% |
| 3 | 1919 | 5.2% |
| 4 | 1592 | 4.3% |
| 7 | 1275 | 3.5% |
| 6 | 1239 | 3.4% |
| 9 | 1115 | 3.0% |
| Other values (7) | 1227 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 92743 | |
| None | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 14445 | 15.6% | |
| E | 5556 | 6.0% |
| R | 4977 | 5.4% |
| A | 4865 | 5.2% |
| 0 | 4542 | 4.9% |
| 1 | 4176 | 4.5% |
| S | 3806 | 4.1% |
| N | 3742 | 4.0% |
| T | 3673 | 4.0% |
| D | 3450 | 3.7% |
| Other values (41) | 39511 |
None
| Value | Count | Frequency (%) |
| Ñ | 1 |
| Distinct | 2682 |
|---|---|
| Distinct (%) | 51.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 19 |
| Mean length | 8.8057143 |
| Min length | 3 |
Characters and Unicode
| Total characters | 46230 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1784 ? |
|---|---|
| Unique (%) | 34.0% |
Sample
| 1st row | ROGERS |
|---|---|
| 2nd row | TUNKHANNOCK |
| 3rd row | TAHLEQUAH |
| 4th row | TRACY |
| 5th row | BENTONVILLE |
| Value | Count | Frequency (%) |
| city | 155 | 2.4% |
| san | 68 | 1.0% |
| beach | 60 | 0.9% |
| springs | 59 | 0.9% |
| fort | 52 | 0.8% |
| lake | 45 | 0.7% |
| north | 44 | 0.7% |
| west | 42 | 0.6% |
| park | 38 | 0.6% |
| las | 37 | 0.6% |
| Other values (2538) | 5986 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 4441 | 9.6% |
| E | 4414 | 9.5% |
| O | 3767 | 8.1% |
| N | 3686 | 8.0% |
| L | 3677 | 8.0% |
| R | 3211 | 6.9% |
| I | 2926 | 6.3% |
| S | 2664 | 5.8% |
| T | 2533 | 5.5% |
| C | 1562 | 3.4% |
| Other values (19) | 13349 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 44892 | |
| Space Separator | 1336 | 2.9% |
| Dash Punctuation | 1 | < 0.1% |
| Other Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 4441 | 9.9% |
| E | 4414 | 9.8% |
| O | 3767 | 8.4% |
| N | 3686 | 8.2% |
| L | 3677 | 8.2% |
| R | 3211 | 7.2% |
| I | 2926 | 6.5% |
| S | 2664 | 5.9% |
| T | 2533 | 5.6% |
| C | 1562 | 3.5% |
| Other values (16) | 12011 |
Space Separator
| Value | Count | Frequency (%) |
| 1336 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 44892 | |
| Common | 1338 | 2.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 4441 | 9.9% |
| E | 4414 | 9.8% |
| O | 3767 | 8.4% |
| N | 3686 | 8.2% |
| L | 3677 | 8.2% |
| R | 3211 | 7.2% |
| I | 2926 | 6.5% |
| S | 2664 | 5.9% |
| T | 2533 | 5.6% |
| C | 1562 | 3.5% |
| Other values (16) | 12011 |
Common
| Value | Count | Frequency (%) |
| 1336 | ||
| - | 1 | 0.1% |
| . | 1 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46230 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 4441 | 9.6% |
| E | 4414 | 9.5% |
| O | 3767 | 8.1% |
| N | 3686 | 8.0% |
| L | 3677 | 8.0% |
| R | 3211 | 6.9% |
| I | 2926 | 6.3% |
| S | 2664 | 5.8% |
| T | 2533 | 5.5% |
| C | 1562 | 3.4% |
| Other values (19) | 13349 |
| Distinct | 1236 |
|---|---|
| Distinct (%) | 23.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 25 |
| Mean length | 7.3194286 |
| Min length | 3 |
Characters and Unicode
| Total characters | 38427 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 574 ? |
|---|---|
| Unique (%) | 10.9% |
Sample
| 1st row | BENTON |
|---|---|
| 2nd row | WYOMING |
| 3rd row | CHEROKEE |
| 4th row | SAN JOAQUIN |
| 5th row | BENTON |
| Value | Count | Frequency (%) |
| st | 82 | 1.4% |
| jefferson | 74 | 1.3% |
| maricopa | 70 | 1.2% |
| orange | 68 | 1.2% |
| san | 67 | 1.1% |
| harris | 60 | 1.0% |
| washington | 57 | 1.0% |
| dallas | 56 | 1.0% |
| tarrant | 53 | 0.9% |
| city | 53 | 0.9% |
| Other values (1251) | 5195 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 4423 | |
| E | 3635 | 9.5% |
| O | 3200 | 8.3% |
| N | 3146 | 8.2% |
| R | 2859 | 7.4% |
| L | 2621 | 6.8% |
| S | 2288 | 6.0% |
| I | 2094 | 5.4% |
| T | 1731 | 4.5% |
| C | 1451 | 3.8% |
| Other values (31) | 10979 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 37715 | |
| Space Separator | 586 | 1.5% |
| Other Punctuation | 86 | 0.2% |
| Dash Punctuation | 23 | 0.1% |
| Lowercase Letter | 17 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 4423 | |
| E | 3635 | 9.6% |
| O | 3200 | 8.5% |
| N | 3146 | 8.3% |
| R | 2859 | 7.6% |
| L | 2621 | 6.9% |
| S | 2288 | 6.1% |
| I | 2094 | 5.6% |
| T | 1731 | 4.6% |
| C | 1451 | 3.8% |
| Other values (16) | 10267 |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 2 | |
| n | 2 | |
| e | 2 | |
| w | 2 | |
| a | 2 | |
| l | 2 | |
| i | 1 | |
| t | 1 | |
| c | 1 | |
| s | 1 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 82 | |
| ' | 4 | 4.7% |
Space Separator
| Value | Count | Frequency (%) |
| 586 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 23 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 37732 | |
| Common | 695 | 1.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 4423 | |
| E | 3635 | 9.6% |
| O | 3200 | 8.5% |
| N | 3146 | 8.3% |
| R | 2859 | 7.6% |
| L | 2621 | 6.9% |
| S | 2288 | 6.1% |
| I | 2094 | 5.5% |
| T | 1731 | 4.6% |
| C | 1451 | 3.8% |
| Other values (27) | 10284 |
Common
| Value | Count | Frequency (%) |
| 586 | ||
| . | 82 | 11.8% |
| - | 23 | 3.3% |
| ' | 4 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38427 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 4423 | |
| E | 3635 | 9.5% |
| O | 3200 | 8.3% |
| N | 3146 | 8.2% |
| R | 2859 | 7.4% |
| L | 2621 | 6.8% |
| S | 2288 | 6.0% |
| I | 2094 | 5.4% |
| T | 1731 | 4.5% |
| C | 1451 | 3.8% |
| Other values (31) | 10979 |
| Distinct | 52 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 10500 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AR |
|---|---|
| 2nd row | PA |
| 3rd row | OK |
| 4th row | CA |
| 5th row | AR |
| Value | Count | Frequency (%) |
| tx | 597 | 11.4% |
| fl | 389 | 7.4% |
| ca | 310 | 5.9% |
| nc | 214 | 4.1% |
| ga | 212 | 4.0% |
| il | 185 | 3.5% |
| oh | 171 | 3.3% |
| pa | 159 | 3.0% |
| mo | 156 | 3.0% |
| tn | 150 | 2.9% |
| Other values (42) | 2707 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1557 | |
| N | 946 | 9.0% |
| T | 861 | 8.2% |
| L | 856 | 8.2% |
| C | 787 | 7.5% |
| I | 643 | 6.1% |
| M | 638 | 6.1% |
| O | 611 | 5.8% |
| X | 597 | 5.7% |
| F | 389 | 3.7% |
| Other values (14) | 2615 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10500 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1557 | |
| N | 946 | 9.0% |
| T | 861 | 8.2% |
| L | 856 | 8.2% |
| C | 787 | 7.5% |
| I | 643 | 6.1% |
| M | 638 | 6.1% |
| O | 611 | 5.8% |
| X | 597 | 5.7% |
| F | 389 | 3.7% |
| Other values (14) | 2615 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10500 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 1557 | |
| N | 946 | 9.0% |
| T | 861 | 8.2% |
| L | 856 | 8.2% |
| C | 787 | 7.5% |
| I | 643 | 6.1% |
| M | 638 | 6.1% |
| O | 611 | 5.8% |
| X | 597 | 5.7% |
| F | 389 | 3.7% |
| Other values (14) | 2615 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10500 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 1557 | |
| N | 946 | 9.0% |
| T | 861 | 8.2% |
| L | 856 | 8.2% |
| C | 787 | 7.5% |
| I | 643 | 6.1% |
| M | 638 | 6.1% |
| O | 611 | 5.8% |
| X | 597 | 5.7% |
| F | 389 | 3.7% |
| Other values (14) | 2615 |
| Distinct | 5157 |
|---|---|
| Distinct (%) | 98.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 52500 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5064 ? |
|---|---|
| Unique (%) | 96.5% |
Sample
| 1st row | 72756-3246 |
|---|---|
| 2nd row | 18657-8071 |
| 3rd row | 74464-5439 |
| 4th row | 95304-9402 |
| 5th row | 72712-5705 |
| Value | Count | Frequency (%) |
| 57106-0704 | 2 | < 0.1% |
| 28083-6426 | 2 | < 0.1% |
| 76542-5201 | 2 | < 0.1% |
| 44011-1069 | 2 | < 0.1% |
| 21237-3034 | 2 | < 0.1% |
| 00659-0000 | 2 | < 0.1% |
| 15301-2974 | 2 | < 0.1% |
| 70345-4053 | 2 | < 0.1% |
| 71111-0000 | 2 | < 0.1% |
| 30165-1913 | 2 | < 0.1% |
| Other values (5147) | 5230 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6925 | |
| 1 | 5370 | |
| 3 | 5342 | |
| 2 | 5294 | |
| - | 5250 | |
| 4 | 4633 | |
| 5 | 4430 | |
| 7 | 4397 | |
| 6 | 4110 | |
| 8 | 3607 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 47250 | |
| Dash Punctuation | 5250 | 10.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 6925 | |
| 1 | 5370 | |
| 3 | 5342 | |
| 2 | 5294 | |
| 4 | 4633 | |
| 5 | 4430 | |
| 7 | 4397 | |
| 6 | 4110 | |
| 8 | 3607 | |
| 9 | 3142 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 52500 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 6925 | |
| 1 | 5370 | |
| 3 | 5342 | |
| 2 | 5294 | |
| - | 5250 | |
| 4 | 4633 | |
| 5 | 4430 | |
| 7 | 4397 | |
| 6 | 4110 | |
| 8 | 3607 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 52500 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 6925 | |
| 1 | 5370 | |
| 3 | 5342 | |
| 2 | 5294 | |
| - | 5250 | |
| 4 | 4633 | |
| 5 | 4430 | |
| 7 | 4397 | |
| 6 | 4110 | |
| 8 | 3607 |
businessunit_status_code
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4851429 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 5 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.5085545 |
|---|---|
| Coefficient of variation (CV) | 0.43285298 |
| Kurtosis | -1.9687251 |
| Mean | 3.4851429 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.022313369 |
| Sum | 18297 |
| Variance | 2.2757365 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 2649 | |
| 5 | 2572 | |
| 6 | 22 | 0.4% |
| 0 | 5 | 0.1% |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 5 | 0.1% |
| 2 | 2649 | |
| 3 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 2572 | |
| 6 | 22 | 0.4% |
| Value | Count | Frequency (%) |
| 6 | 22 | 0.4% |
| 5 | 2572 | |
| 4 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 2 | 2649 | |
| 0 | 5 | 0.1% |
op_status
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.1 KiB |
| Open | |
|---|---|
| Closed | 3 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.0011429 |
| Min length | 4 |
Characters and Unicode
| Total characters | 21006 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Open |
|---|---|
| 2nd row | Open |
| 3rd row | Open |
| 4th row | Open |
| 5th row | Open |
Common Values
| Value | Count | Frequency (%) |
| Open | 5247 | |
| Closed | 3 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| open | 5247 | |
| closed | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 5250 | |
| O | 5247 | |
| p | 5247 | |
| n | 5247 | |
| C | 3 | < 0.1% |
| l | 3 | < 0.1% |
| o | 3 | < 0.1% |
| s | 3 | < 0.1% |
| d | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15756 | |
| Uppercase Letter | 5250 | 25.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 5250 | |
| p | 5247 | |
| n | 5247 | |
| l | 3 | < 0.1% |
| o | 3 | < 0.1% |
| s | 3 | < 0.1% |
| d | 3 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 5247 | |
| C | 3 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 21006 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 5250 | |
| O | 5247 | |
| p | 5247 | |
| n | 5247 | |
| C | 3 | < 0.1% |
| l | 3 | < 0.1% |
| o | 3 | < 0.1% |
| s | 3 | < 0.1% |
| d | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21006 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 5250 | |
| O | 5247 | |
| p | 5247 | |
| n | 5247 | |
| C | 3 | < 0.1% |
| l | 3 | < 0.1% |
| o | 3 | < 0.1% |
| s | 3 | < 0.1% |
| d | 3 | < 0.1% |
Modified_Operating_Hours_
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 33.3% |
| Missing | 5247 |
| Missing (%) | 99.9% |
| Memory size | 10.4 KiB |
| False | 3 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3 | 0.1% |
| (Missing) | 5247 |
Pharmacy_open_to_public_
Boolean
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.3 KiB |
| True | |
|---|---|
| False | 1 |
| Value | Count | Frequency (%) |
| True | 5249 | |
| False | 1 | < 0.1% |
Fuel_Station_open_to_public_
Boolean
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.3 KiB |
| True |
|---|
| Value | Count | Frequency (%) |
| True | 5250 |
bu_num
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 5250 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3184.756 |
| Minimum | 1 |
|---|---|
| Maximum | 9894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 278.45 |
| Q1 | 1371.25 |
| median | 2810.5 |
| Q3 | 4925.75 |
| 95-th percentile | 6955.75 |
| Maximum | 9894 |
| Range | 9893 |
| Interquartile range (IQR) | 3554.5 |
Descriptive statistics
| Standard deviation | 2159.4932 |
|---|---|
| Coefficient of variation (CV) | 0.6780718 |
| Kurtosis | -0.73966895 |
| Mean | 3184.756 |
| Median Absolute Deviation (MAD) | 1694 |
| Skewness | 0.47704628 |
| Sum | 16719969 |
| Variance | 4663411 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 5894 | 1 | < 0.1% |
| 5891 | 1 | < 0.1% |
| 5890 | 1 | < 0.1% |
| 589 | 1 | < 0.1% |
| 5889 | 1 | < 0.1% |
| 5888 | 1 | < 0.1% |
| 5886 | 1 | < 0.1% |
| 5884 | 1 | < 0.1% |
| 5883 | 1 | < 0.1% |
| Other values (5240) | 5240 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 11 | 1 |
| Value | Count | Frequency (%) |
| 9894 | 1 | |
| 8958 | 1 | |
| 8930 | 1 | |
| 8331 | 1 | |
| 8299 | 1 | |
| 8298 | 1 | |
| 8297 | 1 | |
| 8296 | 1 | |
| 8295 | 1 | |
| 8294 | 1 |
Grocery_delivery_service
Boolean
MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 435 |
| Missing (%) | 8.3% |
| Memory size | 10.4 KiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3157 | |
| True | 1658 | |
| (Missing) | 435 | 8.3% |
Grocery_delivery_status
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2385 |
| Missing (%) | 45.4% |
| Memory size | 41.1 KiB |
| Available | |
|---|---|
| Not Available |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.7246073 |
| Min length | 9 |
Characters and Unicode
| Total characters | 27861 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Available |
|---|---|
| 2nd row | Not Available |
| 3rd row | Not Available |
| 4th row | Available |
| 5th row | Available |
Common Values
| Value | Count | Frequency (%) |
| Available | 2346 | |
| Not Available | 519 | 9.9% |
| (Missing) | 2385 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| available | 2865 | |
| not | 519 | 15.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 5730 | |
| l | 5730 | |
| A | 2865 | |
| v | 2865 | |
| i | 2865 | |
| b | 2865 | |
| e | 2865 | |
| N | 519 | 1.9% |
| o | 519 | 1.9% |
| t | 519 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 23958 | |
| Uppercase Letter | 3384 | 12.1% |
| Space Separator | 519 | 1.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 5730 | |
| l | 5730 | |
| v | 2865 | |
| i | 2865 | |
| b | 2865 | |
| e | 2865 | |
| o | 519 | 2.2% |
| t | 519 | 2.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2865 | |
| N | 519 | 15.3% |
Space Separator
| Value | Count | Frequency (%) |
| 519 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27342 | |
| Common | 519 | 1.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 5730 | |
| l | 5730 | |
| A | 2865 | |
| v | 2865 | |
| i | 2865 | |
| b | 2865 | |
| e | 2865 | |
| N | 519 | 1.9% |
| o | 519 | 1.9% |
| t | 519 | 1.9% |
Common
| Value | Count | Frequency (%) |
| 519 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27861 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 5730 | |
| l | 5730 | |
| A | 2865 | |
| v | 2865 | |
| i | 2865 | |
| b | 2865 | |
| e | 2865 | |
| N | 519 | 1.9% |
| o | 519 | 1.9% |
| t | 519 | 1.9% |
Online_grocery_pickup
Boolean
MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 106 |
| Missing (%) | 2.0% |
| Memory size | 10.4 KiB |
| True | |
|---|---|
| False | |
| (Missing) | 106 |
| Value | Count | Frequency (%) |
| True | 3616 | |
| False | 1528 | |
| (Missing) | 106 | 2.0% |
Online_grocery_pickup_status
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1473 |
| Missing (%) | 28.1% |
| Memory size | 41.1 KiB |
| Available | |
|---|---|
| Not Available |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.6703733 |
| Min length | 9 |
Characters and Unicode
| Total characters | 36525 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Available |
|---|---|
| 2nd row | Available |
| 3rd row | Available |
| 4th row | Not Available |
| 5th row | Not Available |
Common Values
| Value | Count | Frequency (%) |
| Available | 3144 | |
| Not Available | 633 | 12.1% |
| (Missing) | 1473 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| available | 3777 | |
| not | 633 | 14.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7554 | |
| l | 7554 | |
| A | 3777 | |
| v | 3777 | |
| i | 3777 | |
| b | 3777 | |
| e | 3777 | |
| N | 633 | 1.7% |
| o | 633 | 1.7% |
| t | 633 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 31482 | |
| Uppercase Letter | 4410 | 12.1% |
| Space Separator | 633 | 1.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 7554 | |
| l | 7554 | |
| v | 3777 | |
| i | 3777 | |
| b | 3777 | |
| e | 3777 | |
| o | 633 | 2.0% |
| t | 633 | 2.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3777 | |
| N | 633 | 14.4% |
Space Separator
| Value | Count | Frequency (%) |
| 633 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35892 | |
| Common | 633 | 1.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 7554 | |
| l | 7554 | |
| A | 3777 | |
| v | 3777 | |
| i | 3777 | |
| b | 3777 | |
| e | 3777 | |
| N | 633 | 1.8% |
| o | 633 | 1.8% |
| t | 633 | 1.8% |
Common
| Value | Count | Frequency (%) |
| 633 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36525 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 7554 | |
| l | 7554 | |
| A | 3777 | |
| v | 3777 | |
| i | 3777 | |
| b | 3777 | |
| e | 3777 | |
| N | 633 | 1.7% |
| o | 633 | 1.7% |
| t | 633 | 1.7% |
| X | Y | objectid | businessunit_number | businessunit_status_code | bu_num | businessunit_banner_description | businessunit_type_description | businessunit_isstoreopen | op_status | Pharmacy_open_to_public_ | Grocery_delivery_service | Grocery_delivery_status | Online_grocery_pickup | Online_grocery_pickup_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| X | 1.000 | 0.087 | -0.053 | 0.023 | 0.012 | 0.023 | 0.136 | 0.040 | 0.079 | 0.000 | 0.000 | 0.067 | 0.082 | 0.030 | 0.058 |
| Y | 0.087 | 1.000 | -0.181 | 0.010 | 0.094 | 0.010 | 0.102 | 0.035 | 0.070 | 0.000 | 0.000 | 0.071 | 0.000 | 0.021 | 0.018 |
| objectid | -0.053 | -0.181 | 1.000 | 0.474 | -0.200 | 0.474 | 0.221 | 0.500 | 0.024 | 0.041 | 0.000 | 0.059 | 0.000 | 0.037 | 0.000 |
| businessunit_number | 0.023 | 0.010 | 0.474 | 1.000 | -0.552 | 1.000 | 0.411 | 0.789 | 0.042 | 0.000 | 0.000 | 0.124 | 0.000 | 0.074 | 0.023 |
| businessunit_status_code | 0.012 | 0.094 | -0.200 | -0.552 | 1.000 | -0.552 | 0.228 | 0.064 | 0.977 | 0.000 | 0.000 | 0.043 | 0.000 | 0.076 | 0.000 |
| bu_num | 0.023 | 0.010 | 0.474 | 1.000 | -0.552 | 1.000 | 0.411 | 0.789 | 0.042 | 0.000 | 0.000 | 0.124 | 0.000 | 0.074 | 0.023 |
| businessunit_banner_description | 0.136 | 0.102 | 0.221 | 0.411 | 0.228 | 0.411 | 1.000 | 0.999 | 0.218 | 0.000 | 0.000 | 0.200 | 0.048 | 0.172 | 0.044 |
| businessunit_type_description | 0.040 | 0.035 | 0.500 | 0.789 | 0.064 | 0.789 | 0.999 | 1.000 | 0.000 | 0.000 | 0.000 | 0.187 | 0.000 | 0.105 | 0.009 |
| businessunit_isstoreopen | 0.079 | 0.070 | 0.024 | 0.042 | 0.977 | 0.042 | 0.218 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.011 | 0.000 |
| op_status | 0.000 | 0.000 | 0.041 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Pharmacy_open_to_public_ | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 1.000 |
| Grocery_delivery_service | 0.067 | 0.071 | 0.059 | 0.124 | 0.043 | 0.124 | 0.200 | 0.187 | 0.000 | 0.000 | 0.000 | 1.000 | 0.331 | 0.422 | 0.249 |
| Grocery_delivery_status | 0.082 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.048 | 0.000 | 0.000 | 0.000 | 1.000 | 0.331 | 1.000 | 0.236 | 0.918 |
| Online_grocery_pickup | 0.030 | 0.021 | 0.037 | 0.074 | 0.076 | 0.074 | 0.172 | 0.105 | 0.011 | 0.000 | 0.000 | 0.422 | 0.236 | 1.000 | 0.175 |
| Online_grocery_pickup_status | 0.058 | 0.018 | 0.000 | 0.023 | 0.000 | 0.023 | 0.044 | 0.009 | 0.000 | 0.000 | 1.000 | 0.249 | 0.918 | 0.175 | 1.000 |
| X | Y | objectid | businessunit_name | businessunit_number | businessunit_banner_description | businessunit_type_description | businessunit_isstoreopen | facilitydetails_location_locati | facilitydetails_location_loca_1 | facilitydetails_location_loca_2 | facilitydetails_location_loca_3 | facilitydetails_location_loca_8 | businessunit_status_code | op_status | Modified_Operating_Hours_ | Pharmacy_open_to_public_ | Fuel_Station_open_to_public_ | bu_num | Grocery_delivery_service | Grocery_delivery_status | Online_grocery_pickup | Online_grocery_pickup_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | -94.149054 | 36.331300 | 29040 | ROGERS, AR | 1 | WM Supercenter | Retail | True | 2110 W WALNUT ST | ROGERS | BENTON | AR | 72756-3246 | 5 | Open | NaN | Y | Y | 1 | Yes | NaN | Yes | Not Available |
| 1 | -75.947441 | 41.523981 | 29041 | TUNKHANNOCK, PA | 2024 | WM Supercenter | Retail | True | 808 HUNTER HWY | TUNKHANNOCK | WYOMING | PA | 18657-8071 | 5 | Open | NaN | Y | Y | 2024 | No | Available | No | Available |
| 2 | -94.979814 | 35.888807 | 29042 | TAHLEQUAH OK | 10 | WM Supercenter | Retail | True | 2020 S MUSKOGEE AVE | TAHLEQUAH | CHEROKEE | OK | 74464-5439 | 5 | Open | NaN | Y | Y | 10 | No | NaN | No | Available |
| 3 | -121.471715 | 37.751659 | 29043 | TRACY, CA | 2025 | WM Supercenter | Retail | True | 3010 W GRANT LINE RD | TRACY | SAN JOAQUIN | CA | 95304-9402 | 5 | Open | NaN | Y | Y | 2025 | No | Not Available | No | Not Available |
| 4 | -94.224844 | 36.368173 | 29044 | BENTONVILLE, AR | 100 | WM Supercenter | Retail | True | 406 S WALTON BLVD | BENTONVILLE | BENTON | AR | 72712-5705 | 5 | Open | NaN | Y | Y | 100 | No | Not Available | No | Not Available |
| 5 | -66.642578 | 17.997360 | 29045 | PONCE-PR | 2026 | WM Supercenter | Retail | True | 3305 AVE.BARAMAYA SUITE 100 | PONCE | PONCE | PR | 00728-0000 | 5 | Open | NaN | Y | Y | 2026 | NaN | NaN | Yes | NaN |
| 6 | -97.477003 | 25.925142 | 29046 | BROWNSVILLE TX | 1000 | WM Supercenter | Retail | True | 2721 BOCA CHICA BLVD | BROWNSVILLE | CAMERON | TX | 78521-3501 | 5 | Open | NaN | Y | Y | 1000 | Yes | NaN | Yes | Available |
| 7 | -78.835052 | 39.624903 | 29047 | LAVALE, MD | 2027 | WM Supercenter | Retail | True | 12500 COUNTRY CLUB MALL RD | LAVALE | ALLEGANY | MD | 21502-7553 | 5 | Open | NaN | Y | Y | 2027 | Yes | Available | Yes | Available |
| 8 | -104.664898 | 38.232316 | 29048 | PUEBLO, CO | 1001 | WM Supercenter | Retail | True | 4080 W NORTHERN AVE | PUEBLO | PUEBLO | CO | 81005-3503 | 5 | Open | NaN | Y | Y | 1001 | Yes | Available | Yes | Available |
| 9 | -117.455339 | 33.937071 | 29049 | RIVERSIDE (S), CA | 2028 | WM Supercenter | Retail | True | 5200 VAN BUREN BLVD | RIVERSIDE | RIVERSIDE | CA | 92503-2544 | 5 | Open | NaN | Y | Y | 2028 | No | NaN | Yes | NaN |
| X | Y | objectid | businessunit_name | businessunit_number | businessunit_banner_description | businessunit_type_description | businessunit_isstoreopen | facilitydetails_location_locati | facilitydetails_location_loca_1 | facilitydetails_location_loca_2 | facilitydetails_location_loca_3 | facilitydetails_location_loca_8 | businessunit_status_code | op_status | Modified_Operating_Hours_ | Pharmacy_open_to_public_ | Fuel_Station_open_to_public_ | bu_num | Grocery_delivery_service | Grocery_delivery_status | Online_grocery_pickup | Online_grocery_pickup_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5240 | -82.455718 | 29.063309 | 36688 | DUNNELLON FL | 960 | WM Supercenter | Retail | True | 11012 NO. WILLIAMS ST | DUNNELLON | MARION | FL | 34432-8310 | 5 | Open | NaN | Y | Y | 960 | Yes | Available | Yes | Available |
| 5241 | -90.498285 | 30.074716 | 36690 | LAPLACE LA | 961 | WM Supercenter | Retail | True | 1616 W AIRLINE HWY | LA PLACE | ST. JOHN THE BAPTIST PARISH | LA | 70068-3331 | 5 | Open | NaN | Y | Y | 961 | No | Available | Yes | Available |
| 5242 | -104.523275 | 37.138728 | 36693 | TRINIDAD CO | 962 | WM Supercenter | Retail | True | 2921 TOUPAL DR | TRINIDAD | LAS ANIMAS | CO | 81082-8740 | 5 | Open | NaN | Y | Y | 962 | Yes | Available | Yes | Available |
| 5243 | -97.794862 | 32.731493 | 36695 | WEATHERFORD TX | 963 | WM Supercenter | Retail | True | 1836 S MAIN ST | WEATHERFORD | PARKER | TX | 76086-5506 | 5 | Open | NaN | Y | Y | 963 | No | Available | Yes | Available |
| 5244 | -106.311596 | 31.682898 | 36698 | EL PASO (S) TX | 964 | WM Supercenter | Retail | True | 9441 ALAMEDA AVE | EL PASO | EL PASO | TX | 79907-5601 | 5 | Open | NaN | Y | Y | 964 | Yes | Available | Yes | Available |
| 5245 | -90.508577 | 44.021024 | 36700 | TOMAH WI | 965 | WM Supercenter | Retail | True | 222 W MCCOY BLVD | TOMAH | MONROE | WI | 54660-3291 | 5 | Open | NaN | Y | Y | 965 | No | NaN | Yes | NaN |
| 5246 | -108.561994 | 37.346568 | 36702 | CORTEZ CO | 966 | WM Supercenter | Retail | True | 1835 E MAIN ST | CORTEZ | MONTEZUMA | CO | 81321-3037 | 5 | Open | NaN | Y | Y | 966 | Yes | NaN | Yes | NaN |
| 5247 | -82.631218 | 28.458397 | 36704 | SPRINGHILL / BROOKSVILLE | 967 | WM Supercenter | Retail | True | 1485 COMMERCIAL WAY | SPRING HILL | HERNANDO | FL | 34606-4525 | 5 | Open | NaN | Y | Y | 967 | Yes | Available | Yes | Available |
| 5248 | -81.722251 | 28.006651 | 36705 | WINTER HAVEN FL | 968 | WM Supercenter | Retail | True | 355 CYPRESS GARDENS BLVD | WINTER HAVEN | POLK | FL | 33880-4452 | 5 | Open | NaN | Y | Y | 968 | Yes | Available | Yes | Available |
| 5249 | -89.088697 | 30.423224 | 36706 | GULFPORT MS | 969 | WM Supercenter | Retail | True | 9350 HIGHWAY 49 | GULFPORT | HARRISON | MS | 39503-4213 | 5 | Open | NaN | Y | Y | 969 | No | Not Available | Yes | Available |